2017-05-04 - 28601 - Break Fix - Carton Labels - Duplicating Quantities (Supplier Portal) #CrystalReportsSupport
BREAK FIX
28601 - 6456 - Carton Labels - Duplicating Quantities (Supplier Portal)
Problem Summary
Need to check for SNC160 duplicating quantities issue in BI Production.
Admin Info
Purpose
|
Need to check for SNC160 duplicating quantities issue in BI Production.
|
Requested by
|
Saravanan Lakshmanan
|
Issue Date
|
05-04-2017
|
Resolved by
|
Dhananjay G
|
Resolved Date
|
12-30-2017
|
Document Status
|
Complete
|
Detailed Problem Description
Comment from Saravanan Lakshmanan on 05/04/2017 in WF:
The duplication has happened only for 4500181923 and not for any other PO's. Possible area to check : UOM (whether it is P12, P6 or Eaches).
Comment from Saravanan Lakshmanan on 06/13/2017 in WF:
Another material has been identified to be duplicating in the reports. Cause: if the material is deleted and reentered then the quantity is showing twice. Need to check the logic in SAP.
PO: 4500194279 Material: 11456296
Solution Analysis and Recommendations
1. Need to check he logic in the report.
2. Need to check the table joins.
3. Need to add EKPO table and filter deletion indicator for removing duplicates.
4. Need to validate the reports with SAP Tables.
5. Need to place the report in BI development and inform NEC for promotion after successful validation.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Resolution
1. Added EKPO table and filtered the deletion indicator for removing duplicates with the following links between the tables:
EKET.EBELN -> EKPO.EBELN
EKET.EBELP -> EKPO.EBELP
2. Added deletion indicator in record selection with the following logic:
{EKPO.LOEKZ} <> 'L'
Release Information
2017-06-22 - 28601 - Rel Notes - Carton Labels - Duplicating Quantities (Supplier Portal)